CREATE TABLE [dbo].[tb_Bancos]
(
[idBanco] [int] NOT NULL IDENTITY(1, 1),
[Descripcion] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create trigger [dbo].[aud_Alta_tb_Bancos] on [dbo].[tb_Bancos] for  insert as insert tb_RegistroAuditoria(idAuditoria,fecha,idusuario,descripcion) values(38,convert(varchar(12),getdate(),103),dbo.sp_usuario(system_user),'AltaBank')
GO
ALTER TABLE [dbo].[tb_Bancos] ADD CONSTRAINT [PK_tb_Bancos] PRIMARY KEY NONCLUSTERED  ([idBanco]) ON [PRIMARY]
GO
